SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5421 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5421 [ RunTime:0.002349s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (157044,469920,135123,635976,585507,15350,145503,736233,811647,259817,398129,360388,332652,228833,250998,933025,585912,693831,180102,752247,362490,1016985,208388,73889,336197,590471,134509,26624,158665,161287,556027,1029023,916967,937524,207305,156468,25552,999511,40464,663395,428931,420732,689648,469145,931564,550956,983203,94485,367197,194917,5324,305554,673482,275164,1030785,899794,610250,1019285,600227,299402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]