SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41804 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41804 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013798,249542,543755,812473,370700,620316,552019,743865,1024563,820188,989582,1017779,88162,369909,889154,217904,629204,596207,412334,2044,942586,761190,862892,61541,273541,705655,703697,429678,932220,882419,800824,257966,688329,340675,693005,721890,234565,393441,381428,157856,975826,796503,215912,58213,926159,646371,1006863,947611,924666,994569,261466,338963,546730,411114,486109,236376,1961,510624,635516,527826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]