SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403203 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403203 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571287,185348,810378,15783,182492,646580,501970,1007819,328661,314058,106636,467782,92804,1002570,838972,415902,492000,567549,551507,13962,405022,745906,589838,16241,262628,983396,619630,660143,905024,272948,522992,540506,293266,618217,218937,945746,889741,519910,600267,533078,724504,649691,557227,280800,180955,794137,872009,25444,61365,736181,392099,571888,984513,999777,524250,517419,567416,692213,467392,566489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]