SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409454 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409454 [ RunTime:0.002811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353614,545942,973288,554684,824164,941483,1047788,911502,99257,627896,700278,82804,253480,1031200,26541,396397,822273,628325,898144,160218,955035,102933,612126,373285,413989,272347,805651,849329,290635,339171,928659,181394,614913,904535,15166,341003,710777,911954,83200,398809,509749,3308,649742,233939,956022,366352,490370,730796,411775,513262,466736,559774,380301,102609,826281,17917,484087,1037840,400383,778078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]