SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685209 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685209 [ RunTime:0.002129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856344,200614,467612,985440,362917,501940,692850,38958,44869,916129,365798,360997,115094,984815,1027833,253041,647076,149165,40244,813103,767361,839057,150397,83663,23561,917681,687264,428489,679362,228445,304878,698559,47935,970742,570379,318023,395191,128901,581035,646278,535632,825198,405004,948048,458137,489893,508329,435377,159276,226649,932028,454951,402216,506078,902590,252642,938125,988425,609682,313598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001031s ]