SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5321 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5321 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40652,678498,887129,77739,642278,322447,911908,320750,640830,387989,673059,15560,855324,617279,1039089,963254,458937,150406,534905,346905,51230,331216,898159,1012241,971310,465775,959757,627164,680728,836234,456978,686838,470475,750078,448243,898036,445115,599567,39821,958130,190408,722340,539677,1014819,233488,618592,833752,946310,220725,408487,428943,561612,435216,610641,145664,611430,878638,934658,766801,851814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]