SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575458 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575458 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92909,435767,940119,850184,569602,411062,805080,880585,337065,121929,44978,750286,335223,627638,928392,432471,578597,55226,966133,900535,145824,1008155,24213,641200,228743,274651,804225,889997,253362,255827,720641,891775,633296,155747,440652,731829,108807,495722,964393,451135,757401,375231,628743,509250,559492,222216,521543,266141,519401,378425,50471,530272,1034655,921718,890955,222300,243226,463668,907474,548660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]