SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014812 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014812 [ RunTime:0.002078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574537,493190,441830,115663,601095,652470,989272,880585,941451,768960,251272,467512,35875,1015725,300282,1015290,332334,565554,77413,241770,731207,251620,515423,966662,572834,60498,178608,147903,647175,668470,921018,1005461,698146,14978,79996,651684,806779,503775,312942,1004305,873678,1032324,580444,69619,451080,355513,1010704,363969,833892,550283,89263,199847,331189,355440,530093,378397,425178,769864,505931,825542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001269s ]