SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 917641 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 917641 [ RunTime:0.001399s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040261,223239,5610,987110,353742,101330,1029577,495891,383365,398081,481299,26806,1013280,49342,689091,775566,37947,536761,477596,905186,218563,440445,328439,144601,439370,894047,386633,377146,533623,1047414,756433,4490,669245,332267,653526,873385,603202,628687,965023,959135,950246,2331,554154,351302,770477,619073,433310,128741,997092,41363,963191,630611,212548,141324,757335,958953,387186,546962,794166,405887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 917641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 917641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]