SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801340 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801340 [ RunTime:0.002940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507372,2676,430624,432934,201920,505993,821673,424856,642276,118592,872235,811898,799309,120889,836980,390075,900199,443761,859347,470252,852791,756121,709439,349043,873409,327835,954197,81384,896013,392621,701909,565339,22128,634577,296471,77623,133028,867907,571957,890076,644201,119392,77386,99927,474392,280041,511917,1261,263140,666138,621547,108441,677214,341341,563006,567270,144238,834524,36873,250015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]