SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041787 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041787 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548768,431057,596026,590727,1004774,519146,453762,1026156,745324,61243,337599,294259,901502,474251,408970,156248,1045396,808272,155756,927473,445980,722101,556155,650693,617085,224364,717293,775281,614532,1036303,268554,586903,798883,904184,923623,798841,557015,203524,112333,333632,690035,1022135,801867,95931,744986,489942,638092,992473,201268,293974,558073,445727,1042995,847562,630605,430423,899199,730647,208546,787168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]