SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318020 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318020 [ RunTime:0.005861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82555,207983,685750,580263,748710,1007523,397503,1003363,891753,1046991,983210,633733,709753,935700,719951,69841,233005,594998,777748,181810,669613,228153,1045922,316551,928848,956650,627539,107731,284485,762108,272877,702038,799347,98538,294277,77799,47922,1034341,141518,877678,161088,808087,221710,749111,624305,98718,745715,427307,393337,859819,843545,360700,347399,526761,763824,787743,83771,737158,332829,287915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001002s ]