SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418026 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418026 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187500,100677,547610,676320,728412,273053,400544,791171,947140,222285,746283,926144,21079,1010531,46041,463294,992034,157656,680840,994668,587141,337149,18493,655697,348942,179676,11847,272955,854027,920063,136714,70321,567458,939420,266091,948568,101669,585921,815876,590488,11723,971001,276430,663670,882844,884688,629009,1036551,46483,722419,453480,52916,763498,566777,715287,224057,998136,296413,295807,398592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000397s ]