SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1191 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1191 [ RunTime:0.001470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (389942,981027,5452,495297,355000,21832,389899,256678,30469,351610,471485,364777,567847,891985,447895,267607,575416,703224,791116,743364,643321,534808,45352,346751,124090,584201,776796,906377,357020,855590,214819,512391,682160,401977,947352,870216,29285,612804,238536,328436,825412,229592,674503,863166,164429,844873,960543,737315,950775,750338,226706,899764,46355,13809,86825,766618,23648,544529,223896,509069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]