SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017090 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017090 [ RunTime:0.006127s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51569,366882,353853,307166,187770,241757,174519,171743,370167,1018089,654508,756936,1024133,918629,816970,408235,947379,824341,879492,607142,1025986,10978,937498,986759,646035,63050,423282,597290,888442,513523,179278,29835,571454,219786,763955,181636,514576,215616,108855,229007,225733,832839,305701,700404,589657,92175,706702,631085,503024,204839,72139,915722,538405,715797,215420,365453,311417,13521,105920,712949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003892s ]