SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002546s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040479 LIMIT 1 [ RunTime:0.001145s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040479 [ RunTime:0.004953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750186,437596,1039900,477158,745558,832119,815222,607682,142909,941026,332085,847447,478636,625992,478394,479136,927384,365666,1023902,798599,23997,240626,505269,226032,597236,129053,157145,662063,79192,440587,953642,421208,286655,664360,245243,379245,72117,699580,991877,71131,947184,24644,467853,629688,470605,735627,1040721,950107,975189,312042,739934,524075,146218,734112,104497,757590,394016,565993,225156,842889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]