SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019677 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019677 [ RunTime:0.002481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349013,222591,162783,810944,352134,214324,851090,922547,1048178,327922,206092,948239,143944,43834,768728,501733,392507,697877,278538,207630,335265,819490,300575,373151,291570,803487,758014,833039,925900,798657,629896,680785,70390,532309,196021,498158,823890,84761,405541,207796,890991,726512,713521,1020090,253323,511055,46765,717053,84753,1008396,845483,637121,464924,47542,123644,481689,453331,721033,260552,53014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019677 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019677 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]