SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38093 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38093 [ RunTime:0.001950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847703,211211,884720,980249,22395,306929,146177,328430,273798,429900,497368,1036837,806175,754991,310593,155008,436174,621325,50155,382695,122374,777728,971897,302528,200207,971871,458247,772557,5169,987666,77977,611321,283970,600056,410201,279914,611657,1023002,354370,658735,421935,514722,835813,690342,370016,895092,493008,654855,9614,951116,772753,200144,111736,959014,247343,579928,611597,209212,811859,621993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001114s ]