SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20116 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20116 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116791,229337,597969,917995,834877,83985,520702,89004,201155,272558,171974,37820,315763,326921,587926,559692,38526,271525,601554,105931,755314,1047491,241439,89353,122932,380985,848226,695905,378926,278268,603887,11885,1034826,611174,961352,114123,816821,815875,579574,426269,513221,992024,908839,1004971,23939,586778,225580,88916,251193,539394,746033,15025,612985,313304,548867,525901,201515,541179,713996,868729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]