SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515110 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515110 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70624,143597,535467,551493,960064,170797,756399,209258,338379,100804,1044160,759752,873293,841787,277944,511583,487226,505842,934158,146089,880790,802713,166498,430136,750575,966763,622879,974972,904722,580069,137755,279195,723620,880271,290920,918082,171085,135960,449604,500909,340824,325888,641186,785521,909902,923924,27744,472148,645503,92822,30975,641767,9713,274242,49534,546332,148989,597200,962570,881498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004207s ]