SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402056 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402056 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614390,748852,43520,843818,502212,228632,332632,195617,216859,368359,800000,855969,446830,159457,576681,771366,28456,397100,98739,506042,53739,1456,189659,394696,559612,970437,728845,820848,228565,592658,873753,647247,648759,643695,295849,728273,336521,386170,715885,620646,215892,695642,607654,115629,293246,130444,202681,707101,457035,516316,152993,112173,1048494,206114,464431,764090,726448,1022409,816249,280192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]