SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004559s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505052 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505052 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70440,572686,236381,675508,854309,355122,112551,962269,761848,969902,2058,277941,891896,350078,415504,294846,497835,511653,506345,905380,340943,270824,145262,35467,887200,941041,29367,390912,685779,726977,958862,659639,544075,348978,482783,27647,292718,139139,948197,168017,897447,267740,318863,1025151,742477,476563,959465,882481,476056,806268,411562,997979,577129,369050,702906,162695,142746,128194,644561,398252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002410s ]