SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40738 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40738 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451172,39154,505087,453314,730810,597029,609631,92412,918080,759042,465161,533956,710368,938096,207216,852422,720253,814731,586626,376388,751751,849056,626860,65671,888159,262168,687069,920565,388823,428585,765375,253144,153346,526235,866205,405513,452461,618375,117308,398390,1001343,618307,891149,804635,1041988,104393,444968,343434,752167,902729,82654,1030507,810914,747462,683223,617234,114460,684685,1018937,145834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]