SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002026s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 144051 LIMIT 1 [ RunTime:0.000937s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144051 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458108,370716,1048810,13108,714448,1021982,428631,277158,599466,231467,644791,847180,222621,490669,430977,35669,399337,307058,782131,548705,879052,36402,383401,1025502,467300,374570,13131,68598,352313,531733,202766,16278,343596,865761,284226,280220,1031832,695292,1025228,229917,89987,596903,877164,788589,730799,328026,1012644,418654,605737,517350,465208,729052,635168,514884,360455,428877,353920,78073,40158,909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]