SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335040 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335040 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048287,662370,455830,303600,240797,240670,1020252,112469,944046,225329,37513,1034297,887099,111538,147029,378651,688835,260440,213879,218223,177886,733471,484742,575574,692788,981579,436187,286416,154570,350895,784240,184762,723399,944962,677424,482282,51076,168210,742332,138252,108929,656318,515296,121584,649026,471436,288324,76379,24800,840326,678991,867920,160123,748305,650284,304959,145276,661759,687791,106325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]