SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 815703 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 815703 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54173,1027140,187338,551937,266701,220585,4211,568078,491820,488643,811298,643070,762580,149104,810043,98830,100845,355909,510081,19789,971331,497550,480031,664201,333193,832484,336115,109050,492208,555322,50994,619784,19041,432022,748814,150349,319878,811828,250267,12951,297885,800732,381421,407796,895822,23446,1002086,187409,505966,238814,1000275,245485,985206,687151,343926,623627,961964,211768,684715,10543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 815703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 815703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]