SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499086 LIMIT 1 [ RunTime:0.001640s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499086 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429365,989028,986014,128922,984794,503235,158757,628693,534655,471281,280952,400208,1022705,623140,407182,679657,242034,571808,56090,1005119,1047918,333102,412045,46136,200441,449320,42204,504249,908182,293546,901663,183063,853606,909439,41257,203328,121917,204177,802558,54240,172837,603626,303611,714667,1019258,270004,775653,850445,565322,891880,449762,432919,1046155,795300,132192,874694,645252,651096,862901,400602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]