SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408085 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408085 [ RunTime:0.001391s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630138,227916,893827,219096,933629,415006,153772,174206,864388,611892,861427,255337,972796,708595,26606,14485,18392,523667,792930,619456,926911,154139,55065,1001506,615355,34133,819842,360651,5784,62663,506621,68114,864033,417945,525969,566572,723921,423592,261896,312042,90105,335896,976019,885675,986010,767402,220205,102490,1026971,85646,949507,561996,593052,824045,196994,461790,314718,339749,416327,974744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]