SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487968 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487968 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98700,1020859,377851,947153,497678,600832,734691,84276,298873,962243,773730,54650,110950,773031,417028,921412,650555,954585,442709,859095,726589,367719,317765,1006378,81926,827602,216437,82810,886751,855226,189003,324092,278045,978863,269524,326330,1035454,172407,1014809,232102,359595,135541,128640,70267,799707,333745,711265,157130,574941,760921,613886,377009,625906,84355,907607,546631,116141,735942,583047,734494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]