SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411903 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411903 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742939,200944,922028,229002,449417,1014689,817188,42013,492149,394685,293875,949068,1016509,467925,214524,902811,721198,627721,238440,836465,280312,332913,340041,605663,224881,547506,1002764,113365,126176,72226,83672,388394,42404,743041,240808,181812,472978,1037574,37381,97484,222229,4082,784995,229264,25199,919208,943246,84148,688852,750299,197314,920700,758585,124415,782263,276521,320117,75753,321754,913690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]