SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501977 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501977 [ RunTime:0.001408s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55747,996420,117120,705128,682762,525168,168874,1017296,310799,281393,669935,304146,648843,661199,405278,912395,839527,158738,991614,388937,8783,405437,510639,516912,459844,418831,103429,818756,433765,775235,430986,458635,883333,217608,625708,660300,398959,885963,646252,828112,233195,814764,334069,410157,269683,881398,500299,262822,591228,113508,795597,1035248,326768,939674,737439,590227,274414,864374,163830,613085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501977 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501977 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]