SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504602 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504602 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026180,529270,381446,344141,992172,324179,264110,1028143,189452,952533,757782,422532,381361,657335,714841,359733,155196,907524,1018200,595268,857984,304713,344019,972971,237363,835881,236132,962720,107974,640149,681768,846674,512278,836441,891516,515500,733645,183590,90016,270813,180069,259868,841592,317129,253499,965354,976287,789943,985303,1046660,295058,756007,115629,359872,18975,580224,199304,839024,337753,950855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504602 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504602 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]