SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569881 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569881 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340082,579576,600821,104297,557526,464705,290691,423313,497585,349771,887267,315067,124690,359753,1023480,548203,605255,312137,653213,148786,254706,325849,480966,609686,867020,853304,570620,1026325,126537,534554,970808,724261,929932,640799,197004,206396,945498,367974,570253,584556,826394,402867,339059,1021177,884169,428009,336028,522215,382800,502853,208190,195303,562346,5356,141297,885368,828910,715847,690767,1024838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]