SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002713 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002713 [ RunTime:0.002747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610152,223445,329665,748298,342962,1018850,765183,13663,737438,750084,419442,963661,35683,611061,905513,48409,858370,706876,158701,401997,452834,170639,334375,122401,281497,707581,628533,255230,830053,1047552,707758,735018,1028207,1046821,183229,684361,479355,345103,1030527,578700,861487,690564,558951,1037320,666492,879195,28740,135044,206800,415410,479043,256373,381610,397176,505964,305290,899328,524144,623264,299597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]