SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531235 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531235 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927547,661599,323023,389148,1027339,56790,711021,1631,22894,701739,117292,361989,843011,216827,247621,5308,570621,625963,350648,522633,264263,532400,88280,356281,556859,556520,697554,411315,74648,928152,202506,1018240,215433,600218,137657,948770,822809,821503,37777,125723,67104,905416,424632,294408,352307,650873,227022,675235,1034115,874562,793728,57845,565635,294485,429776,396469,758990,30015,707904,504794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531235 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531235 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]