SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543570 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543570 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439554,104006,48367,409916,534775,986279,341974,38905,102624,972052,664970,922939,2806,209222,816719,875894,523033,860480,228112,342484,192372,32980,348247,585759,213493,231958,658252,38901,410139,236697,867277,598160,763199,219348,233889,760068,904198,108496,846227,425836,933604,496194,446272,356226,792613,769023,40669,817215,280104,424197,220972,1001091,430002,203987,509190,803172,748880,667634,569247,923898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003800s ]