SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001830s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401756 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401756 [ RunTime:0.002403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256710,372180,459207,971490,491411,596542,330656,482878,83320,441430,910312,917017,826257,303994,807773,260397,199806,314693,25420,609364,44642,904250,106437,929007,801438,274316,785787,601883,723013,838230,945649,69741,665529,966870,784145,390839,641989,815514,14411,886752,276150,56861,42637,536083,630243,617429,841744,768587,951439,160897,321458,715921,759917,229337,622938,266119,418415,167330,404230,1010337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401756 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401756 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001492s ]