SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015421 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015421 [ RunTime:0.002138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023987,1024749,218986,40574,593399,365946,997787,373307,28043,338944,266795,741264,489548,533399,201574,677088,367026,139520,350039,30724,632524,618395,800431,502381,374797,539679,354984,533274,552956,1001111,489225,771585,221112,604715,366578,919764,358459,273913,900614,685292,76811,1285,915094,1032181,979600,611177,323394,909452,268725,232973,518384,595154,372633,519568,338486,593142,503893,935614,404710,914650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]