SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436173 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436173 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028784,375708,875227,204487,533801,480959,826772,627380,10343,649057,999201,920853,65481,261062,136250,848453,230672,972689,975139,12977,112546,138518,40157,236737,857058,154489,1002352,596447,1014376,919951,932053,347576,1029403,947928,804608,377725,350894,860693,487574,784317,687179,356589,779502,973076,362122,65950,681460,610292,412049,375961,330434,818728,774133,233175,311204,213972,320260,247956,1040738,897370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]