SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201658 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201658 [ RunTime:0.004923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617944,213286,344853,753067,552603,468660,986900,576513,975451,502577,704916,563643,826446,185403,548178,73257,116105,527357,937583,128719,1017299,580731,247431,665872,509573,514884,608789,14563,614639,236877,265381,518494,720114,572823,476317,851177,665244,403894,318900,1018653,269044,842433,414386,315456,326411,921422,890305,487585,53979,874700,749801,128537,466385,179707,300453,328570,80173,416743,381901,618647) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]