SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44519 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44519 [ RunTime:0.003109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420089,333739,708479,1039317,702632,532596,415087,821132,565595,542986,179400,532335,517858,842918,881776,496480,680791,51121,937058,730307,498751,695716,23617,330803,890804,692943,986963,420295,287188,541790,555733,462524,140300,44604,865281,6544,142833,951508,640099,873615,355653,995192,101546,926108,1019720,318431,770950,783642,17275,180526,589211,39001,693732,806575,620118,517853,27407,864139,580061,67088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44519 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44519 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]