SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450133 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450133 [ RunTime:0.001407s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729114,775769,851955,273133,1037730,89930,19721,321740,370088,917724,899590,481731,490124,237803,553666,323381,13686,345453,135521,724986,9043,667677,986162,802305,113947,985236,578667,758971,319874,218692,950002,795772,116602,838453,302279,449731,955147,847456,966290,810254,476786,314482,807813,676395,1029205,210663,545174,471942,465279,633839,669281,460865,811681,309952,412016,798737,189132,978883,967474,948070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001345s ]