SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501755 LIMIT 1 [ RunTime:0.000543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501755 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377546,169906,617668,905708,1021138,1505,300203,278024,917343,362178,225664,871720,578399,483400,253031,879571,206450,599084,353263,947776,1027169,189866,275819,225986,767529,140362,789990,763883,493097,17601,736081,261105,132918,347307,572456,870447,248254,742377,46062,1028934,113170,594621,778642,440587,671275,1004808,360074,795139,260689,694919,675724,696016,401748,362669,620728,101532,305030,326780,691666,895803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501755 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501755 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001114s ]