SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191541 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191541 [ RunTime:0.002056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024990,791338,582348,255509,226512,549657,1018398,727592,301560,344840,481454,321729,1023036,127455,759012,282697,362896,50937,12203,537682,303030,860508,970528,392201,574737,809082,684355,552715,513512,680942,999969,387300,498345,1018640,669487,207985,904864,270947,825246,214717,996611,322141,333683,265102,370979,31784,324278,731141,223934,822981,618060,169299,230885,968937,982830,889599,627466,605904,466597,230769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]