SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406097 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406097 [ RunTime:0.002214s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840403,381637,445204,413499,661989,515257,728748,214841,413333,435222,494697,980841,252947,739391,448745,115522,883920,296140,235147,785802,394389,917608,382761,694909,638727,432880,150388,394204,346181,124830,912241,587147,22194,836253,642499,898482,373127,10467,150801,135250,558402,25381,648235,635202,758694,390339,68770,684954,916920,742404,396378,524932,210826,993345,653209,526382,675535,15823,632507,3287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]