SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 260532 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 260532 [ RunTime:0.002147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008323,1028412,543251,427269,376508,814545,110794,422457,667269,923095,181140,759559,900533,279762,985992,669495,575333,229839,294182,113647,767788,79816,468935,281338,723013,181434,178169,85155,100705,177019,1005658,979317,969925,237628,407569,294191,835230,524265,337966,190380,984210,45270,620871,569805,332203,581787,601923,356980,690854,587632,925679,190481,1038796,910944,559555,502173,212667,520169,239164,259215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 260532 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 260532 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]