SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455710 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455710 [ RunTime:0.002465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911484,116546,996868,666828,790938,55348,245839,325614,975074,254501,557753,592133,199881,634902,93078,356918,198012,1006893,239058,296196,328325,498028,269365,871726,207269,455666,621504,688838,987503,11095,366032,107016,811409,41263,847977,175276,391185,456420,771461,1005914,266303,241638,63205,295032,941119,157604,193634,810918,170072,868809,613631,45537,644032,750867,63079,388600,690877,475129,321335,26124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]