SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410650 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410650 [ RunTime:0.003448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270545,922324,174604,531139,290760,587737,405399,733063,747801,173660,769716,813630,861298,850112,922581,247694,631804,174087,641417,266163,93150,879847,435025,131513,878034,213712,851953,908191,261175,740444,1038789,985351,51035,602907,952506,342860,852316,515117,410086,640921,709968,630447,585892,641163,964784,916754,179883,986250,840017,148472,505425,708880,69281,72575,70786,914722,390063,383316,1037092,173320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]