SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000040 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000040 [ RunTime:0.002274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419442,748965,576453,663346,842343,703524,941322,172683,245636,980425,185504,408474,50980,310562,907671,1029362,714880,402622,238054,652835,923911,51751,390726,74959,797695,807472,42775,462860,374907,252155,572610,277204,17907,950962,206215,1043318,908473,648865,533137,557274,691972,812289,955571,471858,67267,52906,1043112,640396,265681,1007677,143976,121139,396623,837760,626538,739987,666212,223137,365826,607137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001656s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000383s ]