SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 622212 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 622212 [ RunTime:0.002712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938102,428551,108240,567729,111249,905244,698665,594164,89149,1021982,40058,1024679,904337,1041319,323537,332906,617486,497576,604031,114294,1028597,1027739,2767,445284,91960,1020503,269049,82528,371921,756439,272791,363904,374240,506699,298582,369703,109018,233519,913639,437287,925634,342961,919535,553441,834734,375578,7643,594098,532279,663346,803940,343039,556869,626593,412391,1040671,324509,548210,47477,891482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 622212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 622212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]