SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401941 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401941 [ RunTime:0.004132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89876,970613,742522,712561,266341,701002,220127,75147,670555,955675,582449,771725,671759,164142,95298,839071,879746,328966,150211,642967,1000804,383108,35612,23922,247207,506604,548358,951172,511848,995274,136275,242641,609774,1007088,374314,524587,852543,503100,930061,393327,586713,123092,286380,107926,358656,369228,330838,404597,110454,117720,178505,470670,72365,383475,510625,698554,101076,857030,1029505,151793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]