SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534080 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534080 [ RunTime:0.002475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633108,197024,916537,770520,34817,381299,209222,680726,129101,46192,828414,940275,908575,738754,999288,1017329,100926,110814,244214,5488,725001,213505,452235,705570,1007499,612275,754497,524358,820321,130521,592989,8713,473301,872241,424942,453572,799208,846041,499623,761563,327381,76628,17141,412718,228403,558822,700849,891687,280766,784054,515930,215181,549549,712529,556403,940214,848537,782311,751391,240742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]