SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004475s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486263 LIMIT 1 [ RunTime:0.004691s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486263 [ RunTime:0.005375s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101038,652829,711944,694139,502422,883746,180486,766315,883285,711626,842924,616316,753537,251249,647244,705835,906941,232083,679448,152408,630558,603008,547070,1014999,1036291,738687,400198,766888,673772,819228,1011058,75124,401732,288979,225321,186833,479938,552009,186460,726253,132099,280430,672654,5223,219667,900211,291848,77809,993169,71642,265485,818022,130438,1040396,603329,10443,773706,9377,977292,239270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000905s ]