SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 656814 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 656814 [ RunTime:0.002362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493988,537104,180510,383537,743129,252952,936586,655158,943119,822439,102391,391081,985405,537705,179808,954980,394136,331494,477588,542200,576172,538824,499976,979868,426974,55661,812503,518760,423003,271810,635381,440489,670867,600018,925315,385536,768866,603850,736497,387041,824699,811292,137124,260900,618246,397777,675869,782640,876167,379010,904216,1036048,4030,686124,225697,929368,469375,475201,52506,230339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 656814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 656814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]