SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390918 LIMIT 1 [ RunTime:0.000745s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390918 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219774,712208,1030011,998621,123973,675676,1001022,492953,804129,696762,448578,894357,184273,667291,567456,493982,292356,968559,804431,733210,430237,188484,563556,699587,899011,650010,28533,107543,244091,619462,197958,1026860,348820,125373,29632,733803,854374,269295,189351,229205,128851,1034804,624978,638661,935121,693559,226262,133640,149411,478768,264421,60289,430400,179308,813183,206950,1040228,628539,161309,562230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]