SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454212 LIMIT 1 [ RunTime:0.001088s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454212 [ RunTime:0.002808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873188,679264,96227,1013544,640341,656600,846243,840268,64663,655081,1032864,316802,404714,385837,21944,1027908,244380,146538,421707,439100,619779,907191,1007881,1034053,1028238,991791,835410,546261,152285,203593,711516,643620,538368,867913,881821,96416,698614,1040385,364967,787295,632879,101105,239202,638210,617075,880814,780180,957452,481435,412474,979863,380210,42652,945243,586399,849627,949242,82305,400235,952457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]