SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 785086 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 785086 [ RunTime:0.002348s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023551,1010643,726767,398388,221259,1035743,242525,1020302,720415,471156,975166,671395,866862,396682,843508,762983,40217,932328,655040,419042,580131,698160,300592,839754,638158,969962,408207,392338,894945,973714,337643,949795,337664,506346,553080,1044536,115211,407061,633539,689885,911149,637222,335148,544052,129522,804551,1042737,682571,898835,547145,976905,100951,559026,87709,324165,162384,189770,86708,231728,308578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 785086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 785086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]