SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411608 LIMIT 1 [ RunTime:0.001391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411608 [ RunTime:0.002323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359782,580873,151433,805435,179070,818572,822544,537547,70545,508958,220820,60607,193809,538009,428680,291257,1023482,118692,993182,702021,1020004,852761,646789,208816,703103,97508,235344,218339,538340,170587,914262,598895,977395,616729,519926,195280,487964,577474,765065,447120,374838,67977,84793,119018,685724,190080,942552,662793,777103,524865,121853,792264,523455,437188,918887,21708,778230,100316,631485,346291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002575s ]