SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474591 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474591 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397974,705923,258671,1046130,646739,934688,513395,581724,535763,730239,235755,659398,639748,620901,233108,326964,589132,794669,53266,456844,673149,2947,853861,862483,252474,64011,656264,909328,298520,845485,313120,646204,875449,296369,34985,283183,311955,95413,983975,845344,547713,684643,270231,407215,934470,282013,744390,830764,573129,17941,613831,109335,377488,274178,469573,864052,79526,628270,897591,175035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002809s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]