SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575695 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575695 [ RunTime:0.003295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673710,1009169,412887,496443,751781,698001,629363,898573,218481,490509,932141,862952,130308,120975,197827,590831,365128,727889,646284,314523,136416,1018603,285902,336382,456234,197029,333963,499210,117898,435556,637910,740787,788164,1046311,296328,1010698,430202,619036,388893,724654,473184,14515,172218,977904,109845,619603,343291,521397,438121,265827,669251,556503,30911,213914,469715,384742,1002461,29044,683620,847797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575695 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575695 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]