SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027828 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027828 [ RunTime:0.005010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812512,508717,599702,398017,364512,436989,421625,704369,962729,462995,649640,156076,883918,401458,576145,622354,428039,887435,30282,505246,760754,202090,331973,450574,113092,477357,418717,966691,799538,1005621,916312,764316,773473,424976,161287,532068,217210,52143,741076,389292,543541,972077,556982,986969,203083,937193,661527,658759,41849,22227,1011081,107898,954444,3560,868111,570367,8708,829747,201597,840830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000823s ]