SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267412 LIMIT 1 [ RunTime:0.001148s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267412 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320064,662039,612598,104997,568882,967713,427142,749929,985540,886161,291396,67148,992716,432394,183794,981692,112845,540944,47591,804471,37712,13164,380602,942588,271006,660755,950666,659634,7248,220003,97397,554269,361816,302195,336767,40034,263099,949831,228323,339867,104103,589463,287842,1020400,840435,420474,177078,309574,796530,499510,626827,234836,285570,322683,966810,16104,82035,794245,922717,397436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]