SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417396 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417396 [ RunTime:0.002102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175671,1003465,748356,636529,23844,745563,140295,488244,811483,28262,205965,1018614,464397,501846,406556,1001208,180377,196939,392221,260696,750470,307878,32422,622909,120167,498588,249416,535023,251207,118539,389501,249718,775206,305300,697371,519877,25788,149986,164659,809980,768452,65104,699770,183315,354470,758108,406024,51416,710276,761898,480862,57607,987590,512143,691616,422880,721898,707319,809467,97160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]