SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441706 LIMIT 1 [ RunTime:0.000800s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441706 [ RunTime:0.001959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283040,155912,839849,749006,561216,981623,585774,661722,123161,826090,408785,139693,371268,613246,638015,196684,229803,428524,672582,619804,165836,405644,761960,264821,989905,526670,249780,932017,926532,738245,476833,41287,953104,176079,224700,233060,981224,273093,788296,457748,279177,482278,245249,439469,374621,481609,529563,455060,304771,402197,33971,856550,24771,909723,890564,349464,245215,768024,317130,37505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]